Overview

Dataset statistics

Number of variables12
Number of observations2969
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory266.9 KiB
Average record size in memory92.0 B

Variable types

Numeric12

Alerts

gross_revenue is highly correlated with invoice_no and 4 other fieldsHigh correlation
recency_days is highly correlated with invoice_noHigh correlation
invoice_no is highly correlated with gross_revenue and 1 other fieldsHigh correlation
quantity is highly correlated with gross_revenue and 1 other fieldsHigh correlation
avg_ticket is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_recency_days is highly correlated with frequencyHigh correlation
frequency is highly correlated with avg_recency_daysHigh correlation
avg_basket_size is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_unique_basket_size is highly correlated with avg_ticketHigh correlation
q_returns is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_ticket is highly skewed (γ1 = 53.4442279) Skewed
q_returns is highly skewed (γ1 = 51.79774426) Skewed
avg_basket_size is highly skewed (γ1 = 44.68328098) Skewed
df_index has unique values Unique
customer_id has unique values Unique
recency_days has 34 (1.1%) zeros Zeros
q_returns has 1481 (49.9%) zeros Zeros

Reproduction

Analysis started2022-10-26 12:45:53.006650
Analysis finished2022-10-26 12:46:16.710957
Duration23.7 seconds
Software versionpandas-profiling v3.4.0
Download configurationconfig.json

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2317.292354
Minimum0
Maximum5715
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:16.841976image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile185.4
Q1929
median2120
Q33537
95-th percentile5035.2
Maximum5715
Range5715
Interquartile range (IQR)2608

Descriptive statistics

Standard deviation1554.944589
Coefficient of variation (CV)0.6710178739
Kurtosis-1.010787014
Mean2317.292354
Median Absolute Deviation (MAD)1271
Skewness0.342284058
Sum6880041
Variance2417852.674
MonotonicityStrictly increasing
2022-10-26T09:46:16.964360image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01
 
< 0.1%
30111
 
< 0.1%
29961
 
< 0.1%
29991
 
< 0.1%
30001
 
< 0.1%
30011
 
< 0.1%
30021
 
< 0.1%
30051
 
< 0.1%
30071
 
< 0.1%
30081
 
< 0.1%
Other values (2959)2959
99.7%
ValueCountFrequency (%)
01
< 0.1%
11
< 0.1%
21
< 0.1%
31
< 0.1%
41
< 0.1%
51
< 0.1%
61
< 0.1%
71
< 0.1%
81
< 0.1%
91
< 0.1%
ValueCountFrequency (%)
57151
< 0.1%
56961
< 0.1%
56861
< 0.1%
56801
< 0.1%
56591
< 0.1%
56551
< 0.1%
56491
< 0.1%
56381
< 0.1%
56371
< 0.1%
56271
< 0.1%

customer_id
Real number (ℝ≥0)

UNIQUE

Distinct2969
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15270.77299
Minimum12347
Maximum18287
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.7 KiB
2022-10-26T09:46:17.107827image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum12347
5-th percentile12619.4
Q113799
median15221
Q316768
95-th percentile17964.6
Maximum18287
Range5940
Interquartile range (IQR)2969

Descriptive statistics

Standard deviation1718.990292
Coefficient of variation (CV)0.1125673398
Kurtosis-1.206094692
Mean15270.77299
Median Absolute Deviation (MAD)1488
Skewness0.03160785866
Sum45338925
Variance2954927.624
MonotonicityNot monotonic
2022-10-26T09:46:17.235621image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178501
 
< 0.1%
175881
 
< 0.1%
149051
 
< 0.1%
161031
 
< 0.1%
146261
 
< 0.1%
148681
 
< 0.1%
182461
 
< 0.1%
171151
 
< 0.1%
166111
 
< 0.1%
159121
 
< 0.1%
Other values (2959)2959
99.7%
ValueCountFrequency (%)
123471
< 0.1%
123481
< 0.1%
123521
< 0.1%
123561
< 0.1%
123581
< 0.1%
123591
< 0.1%
123601
< 0.1%
123621
< 0.1%
123641
< 0.1%
123701
< 0.1%
ValueCountFrequency (%)
182871
< 0.1%
182831
< 0.1%
182821
< 0.1%
182771
< 0.1%
182761
< 0.1%
182741
< 0.1%
182731
< 0.1%
182721
< 0.1%
182701
< 0.1%
182691
< 0.1%

gross_revenue
Real number (ℝ≥0)

HIGH CORRELATION

Distinct2954
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2749.226056
Minimum6.2
Maximum279138.02
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:17.382777image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum6.2
5-th percentile229.77
Q1570.96
median1086.92
Q32308.06
95-th percentile7219.68
Maximum279138.02
Range279131.82
Interquartile range (IQR)1737.1

Descriptive statistics

Standard deviation10580.4905
Coefficient of variation (CV)3.848534202
Kurtosis353.9585684
Mean2749.226056
Median Absolute Deviation (MAD)672.72
Skewness16.77787915
Sum8162452.16
Variance111946779.3
MonotonicityNot monotonic
2022-10-26T09:46:17.512230image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178.962
 
0.1%
533.332
 
0.1%
889.932
 
0.1%
2053.022
 
0.1%
745.062
 
0.1%
379.652
 
0.1%
2092.322
 
0.1%
731.92
 
0.1%
1353.742
 
0.1%
3312
 
0.1%
Other values (2944)2949
99.3%
ValueCountFrequency (%)
6.21
< 0.1%
13.31
< 0.1%
151
< 0.1%
36.561
< 0.1%
451
< 0.1%
521
< 0.1%
52.21
< 0.1%
52.21
< 0.1%
62.431
< 0.1%
68.841
< 0.1%
ValueCountFrequency (%)
279138.021
< 0.1%
259657.31
< 0.1%
194550.791
< 0.1%
168472.51
< 0.1%
140438.721
< 0.1%
124564.531
< 0.1%
117375.631
< 0.1%
91062.381
< 0.1%
72882.091
< 0.1%
66653.561
< 0.1%

recency_days
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct272
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.28864938
Minimum0
Maximum373
Zeros34
Zeros (%)1.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:17.659494image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q111
median31
Q381
95-th percentile242
Maximum373
Range373
Interquartile range (IQR)70

Descriptive statistics

Standard deviation77.75617089
Coefficient of variation (CV)1.209485215
Kurtosis2.778038567
Mean64.28864938
Median Absolute Deviation (MAD)26
Skewness1.798396863
Sum190873
Variance6046.022112
MonotonicityNot monotonic
2022-10-26T09:46:17.803588image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
199
 
3.3%
487
 
2.9%
285
 
2.9%
385
 
2.9%
876
 
2.6%
1067
 
2.3%
966
 
2.2%
766
 
2.2%
1764
 
2.2%
2255
 
1.9%
Other values (262)2219
74.7%
ValueCountFrequency (%)
034
 
1.1%
199
3.3%
285
2.9%
385
2.9%
487
2.9%
543
1.4%
766
2.2%
876
2.6%
966
2.2%
1067
2.3%
ValueCountFrequency (%)
3732
0.1%
3724
0.1%
3711
 
< 0.1%
3681
 
< 0.1%
3664
0.1%
3652
0.1%
3641
 
< 0.1%
3601
 
< 0.1%
3591
 
< 0.1%
3584
0.1%

invoice_no
Real number (ℝ≥0)

HIGH CORRELATION

Distinct56
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.72280229
Minimum1
Maximum206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:18.102743image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile17
Maximum206
Range205
Interquartile range (IQR)4

Descriptive statistics

Standard deviation8.85665393
Coefficient of variation (CV)1.547607882
Kurtosis190.8253633
Mean5.72280229
Median Absolute Deviation (MAD)2
Skewness10.76645634
Sum16991
Variance78.44031883
MonotonicityNot monotonic
2022-10-26T09:46:18.241387image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2786
26.5%
3498
16.8%
4393
13.2%
5237
 
8.0%
1190
 
6.4%
6173
 
5.8%
7138
 
4.6%
898
 
3.3%
969
 
2.3%
1055
 
1.9%
Other values (46)332
11.2%
ValueCountFrequency (%)
1190
 
6.4%
2786
26.5%
3498
16.8%
4393
13.2%
5237
 
8.0%
6173
 
5.8%
7138
 
4.6%
898
 
3.3%
969
 
2.3%
1055
 
1.9%
ValueCountFrequency (%)
2061
< 0.1%
1991
< 0.1%
1241
< 0.1%
971
< 0.1%
912
0.1%
861
< 0.1%
721
< 0.1%
622
0.1%
601
< 0.1%
571
< 0.1%

quantity
Real number (ℝ≥0)

HIGH CORRELATION

Distinct48
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.62142135
Minimum1
Maximum102
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:18.378139image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4
Q18
median11
Q314
95-th percentile22
Maximum102
Range101
Interquartile range (IQR)6

Descriptive statistics

Standard deviation6.263166122
Coefficient of variation (CV)0.5389328836
Kurtosis25.43515698
Mean11.62142135
Median Absolute Deviation (MAD)3
Skewness3.104298882
Sum34504
Variance39.22724987
MonotonicityNot monotonic
2022-10-26T09:46:18.517473image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
10288
 
9.7%
9262
 
8.8%
11255
 
8.6%
12220
 
7.4%
8217
 
7.3%
7212
 
7.1%
13199
 
6.7%
14165
 
5.6%
6157
 
5.3%
15138
 
4.6%
Other values (38)856
28.8%
ValueCountFrequency (%)
119
 
0.6%
232
 
1.1%
360
 
2.0%
482
 
2.8%
5105
 
3.5%
6157
5.3%
7212
7.1%
8217
7.3%
9262
8.8%
10288
9.7%
ValueCountFrequency (%)
1021
 
< 0.1%
741
 
< 0.1%
582
0.1%
571
 
< 0.1%
561
 
< 0.1%
541
 
< 0.1%
502
0.1%
493
0.1%
444
0.1%
431
 
< 0.1%

avg_ticket
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED

Distinct2966
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51.90005685
Minimum2.150588235
Maximum56157.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:18.651089image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum2.150588235
5-th percentile4.916661099
Q113.11933333
median17.97438356
Q324.98828571
95-th percentile90.497
Maximum56157.5
Range56155.34941
Interquartile range (IQR)11.86895238

Descriptive statistics

Standard deviation1036.934336
Coefficient of variation (CV)19.9794451
Kurtosis2890.70744
Mean51.90005685
Median Absolute Deviation (MAD)5.994222271
Skewness53.4442279
Sum154091.2688
Variance1075232.818
MonotonicityNot monotonic
2022-10-26T09:46:18.770029image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
152
 
0.1%
4.1622
 
0.1%
14.478333332
 
0.1%
18.152222221
 
< 0.1%
13.927368421
 
< 0.1%
36.244117651
 
< 0.1%
29.784166671
 
< 0.1%
22.87926231
 
< 0.1%
20.511041671
 
< 0.1%
149.0251
 
< 0.1%
Other values (2956)2956
99.6%
ValueCountFrequency (%)
2.1505882351
< 0.1%
2.43251
< 0.1%
2.4623711341
< 0.1%
2.5112413791
< 0.1%
2.5153333331
< 0.1%
2.651
< 0.1%
2.6569318181
< 0.1%
2.7075982531
< 0.1%
2.7606215721
< 0.1%
2.7704641911
< 0.1%
ValueCountFrequency (%)
56157.51
< 0.1%
4453.431
< 0.1%
3202.921
< 0.1%
1687.21
< 0.1%
952.98751
< 0.1%
872.131
< 0.1%
841.02144931
< 0.1%
651.16833331
< 0.1%
6401
< 0.1%
624.41
< 0.1%

avg_recency_days
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1258
Distinct (%)42.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.35143043
Minimum1
Maximum366
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:18.899392image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8
Q125.92857143
median48.28571429
Q385.33333333
95-th percentile201
Maximum366
Range365
Interquartile range (IQR)59.4047619

Descriptive statistics

Standard deviation63.54282948
Coefficient of variation (CV)0.9434518178
Kurtosis4.887703174
Mean67.35143043
Median Absolute Deviation (MAD)26.28571429
Skewness2.062908983
Sum199966.397
Variance4037.691178
MonotonicityNot monotonic
2022-10-26T09:46:19.040159image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1425
 
0.8%
422
 
0.7%
7021
 
0.7%
720
 
0.7%
3519
 
0.6%
4918
 
0.6%
2117
 
0.6%
4617
 
0.6%
1117
 
0.6%
116
 
0.5%
Other values (1248)2777
93.5%
ValueCountFrequency (%)
116
0.5%
1.51
 
< 0.1%
213
0.4%
2.51
 
< 0.1%
2.6013986011
 
< 0.1%
315
0.5%
3.3214285711
 
< 0.1%
3.3303571431
 
< 0.1%
3.52
 
0.1%
422
0.7%
ValueCountFrequency (%)
3661
 
< 0.1%
3651
 
< 0.1%
3631
 
< 0.1%
3621
 
< 0.1%
3572
0.1%
3561
 
< 0.1%
3552
0.1%
3521
 
< 0.1%
3512
0.1%
3503
0.1%

frequency
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1350
Distinct (%)45.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.06327172298
Minimum0.005449591281
Maximum3
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:19.481632image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0.005449591281
5-th percentile0.009433962264
Q10.01777777778
median0.02941176471
Q30.05540166205
95-th percentile0.2222222222
Maximum3
Range2.994550409
Interquartile range (IQR)0.03762388427

Descriptive statistics

Standard deviation0.1344819335
Coefficient of variation (CV)2.125466593
Kurtosis121.5596918
Mean0.06327172298
Median Absolute Deviation (MAD)0.01433823529
Skewness8.773426515
Sum187.8537455
Variance0.01808539044
MonotonicityNot monotonic
2022-10-26T09:46:19.613739image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.166666666721
 
0.7%
0.333333333321
 
0.7%
0.0277777777820
 
0.7%
0.0909090909119
 
0.6%
0.062517
 
0.6%
0.133333333316
 
0.5%
0.416
 
0.5%
0.2515
 
0.5%
0.0238095238115
 
0.5%
0.0357142857115
 
0.5%
Other values (1340)2794
94.1%
ValueCountFrequency (%)
0.0054495912811
 
< 0.1%
0.0054644808741
 
< 0.1%
0.0054945054951
 
< 0.1%
0.0055096418731
 
< 0.1%
0.0055865921792
0.1%
0.0056022408961
 
< 0.1%
0.0056179775282
0.1%
0.005665722381
 
< 0.1%
0.0056818181822
0.1%
0.0056980056983
0.1%
ValueCountFrequency (%)
31
 
< 0.1%
21
 
< 0.1%
1.5714285711
 
< 0.1%
1.53
 
0.1%
114
0.5%
0.83333333331
 
< 0.1%
0.751
 
< 0.1%
0.666666666712
0.4%
0.65147453081
 
< 0.1%
0.61
 
< 0.1%

q_returns
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct214
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62.1569552
Minimum0
Maximum80995
Zeros1481
Zeros (%)49.9%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:19.750516image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q39
95-th percentile100.6
Maximum80995
Range80995
Interquartile range (IQR)9

Descriptive statistics

Standard deviation1512.496135
Coefficient of variation (CV)24.33349783
Kurtosis2765.52864
Mean62.1569552
Median Absolute Deviation (MAD)1
Skewness51.79774426
Sum184544
Variance2287644.557
MonotonicityNot monotonic
2022-10-26T09:46:19.903012image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01481
49.9%
1164
 
5.5%
2148
 
5.0%
3105
 
3.5%
489
 
3.0%
678
 
2.6%
561
 
2.1%
1251
 
1.7%
843
 
1.4%
743
 
1.4%
Other values (204)706
23.8%
ValueCountFrequency (%)
01481
49.9%
1164
 
5.5%
2148
 
5.0%
3105
 
3.5%
489
 
3.0%
561
 
2.1%
678
 
2.6%
743
 
1.4%
843
 
1.4%
941
 
1.4%
ValueCountFrequency (%)
809951
< 0.1%
90141
< 0.1%
80041
< 0.1%
44271
< 0.1%
37681
< 0.1%
33321
< 0.1%
28781
< 0.1%
20221
< 0.1%
20121
< 0.1%
17761
< 0.1%

avg_basket_size
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED

Distinct1973
Distinct (%)66.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean249.349541
Minimum1
Maximum40498.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:20.073112image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44
Q1103.25
median172
Q3281.5
95-th percentile599.52
Maximum40498.5
Range40497.5
Interquartile range (IQR)178.25

Descriptive statistics

Standard deviation791.5024106
Coefficient of variation (CV)3.174268569
Kurtosis2256.245507
Mean249.349541
Median Absolute Deviation (MAD)82.75
Skewness44.68328098
Sum740318.7873
Variance626476.066
MonotonicityNot monotonic
2022-10-26T09:46:20.210090image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10011
 
0.4%
11410
 
0.3%
739
 
0.3%
869
 
0.3%
829
 
0.3%
1368
 
0.3%
608
 
0.3%
758
 
0.3%
888
 
0.3%
717
 
0.2%
Other values (1963)2882
97.1%
ValueCountFrequency (%)
12
0.1%
21
< 0.1%
3.3333333331
< 0.1%
5.3333333331
< 0.1%
5.6666666671
< 0.1%
6.1428571431
< 0.1%
7.51
< 0.1%
91
< 0.1%
9.51
< 0.1%
111
< 0.1%
ValueCountFrequency (%)
40498.51
< 0.1%
6009.3333331
< 0.1%
42821
< 0.1%
39061
< 0.1%
3868.651
< 0.1%
28801
< 0.1%
28011
< 0.1%
2733.9444441
< 0.1%
2518.7692311
< 0.1%
2160.3333331
< 0.1%

avg_unique_basket_size
Real number (ℝ≥0)

HIGH CORRELATION

Distinct1010
Distinct (%)34.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.15507374
Minimum1
Maximum299.7058824
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2022-10-26T09:46:20.365157image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.345454545
Q110
median17.2
Q327.75
95-th percentile56.94
Maximum299.7058824
Range298.7058824
Interquartile range (IQR)17.75

Descriptive statistics

Standard deviation19.51303316
Coefficient of variation (CV)0.8807478316
Kurtosis27.69469772
Mean22.15507374
Median Absolute Deviation (MAD)8.2
Skewness3.498252107
Sum65778.41393
Variance380.7584629
MonotonicityNot monotonic
2022-10-26T09:46:20.486948image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1353
 
1.8%
1440
 
1.3%
1138
 
1.3%
2033
 
1.1%
933
 
1.1%
132
 
1.1%
1831
 
1.0%
1030
 
1.0%
1629
 
1.0%
1728
 
0.9%
Other values (1000)2622
88.3%
ValueCountFrequency (%)
132
1.1%
1.21
 
< 0.1%
1.251
 
< 0.1%
1.3333333332
 
0.1%
1.58
 
0.3%
1.5681818181
 
< 0.1%
1.5714285711
 
< 0.1%
1.6666666674
 
0.1%
1.8333333331
 
< 0.1%
224
0.8%
ValueCountFrequency (%)
299.70588241
< 0.1%
2591
< 0.1%
203.51
< 0.1%
1481
< 0.1%
1451
< 0.1%
136.1251
< 0.1%
135.51
< 0.1%
1271
< 0.1%
1221
< 0.1%
1181
< 0.1%

Interactions

2022-10-26T09:46:14.731114image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:58.762505image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.375240image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.850672image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.426322image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.802961image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.106024image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.556696image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.886851image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.258853image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.606260image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.211210image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.858900image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:58.926217image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.506244image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.971525image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.541488image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.912065image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.209034image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.664054image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.001517image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.372227image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.723487image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.334315image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.994049image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.068219image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.643107image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.093580image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.653524image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.020033image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.316912image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.773369image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.109259image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.480287image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.837492image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.454681image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.134066image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.199327image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.765107image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.218588image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.767001image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.123042image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.422920image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.880131image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.228106image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.589934image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.953633image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.572938image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.281719image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.332789image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.884428image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.357596image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.881086image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.233468image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.532109image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.997275image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.345127image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.706417image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.071932image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.694056image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.393446image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.448084image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.996878image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.472291image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.990212image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.330894image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.634121image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.102488image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.452100image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.810451image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.186680image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.807825image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.506449image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.575454image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.115794image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.583932image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.099242image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.431431image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.736008image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.207155image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.563136image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.918634image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.299709image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.932325image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.619164image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.702250image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.225968image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.839377image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.211970image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.537090image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.843039image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.314405image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.673323image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.025668image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.412723image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.063841image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.739170image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.831252image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.349490image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:02.950802image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.329218image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.656092image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.952970image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.427046image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.790869image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.141421image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.533467image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.195249image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.854863image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:45:59.962816image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.473168image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.062064image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.441260image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.766095image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.061935image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.539062image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:09.905194image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.253583image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.843517image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.320106image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:15.996078image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.103705image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.603165image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.179072image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.562145image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:05.883837image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.335248image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.658072image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.024659image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.370192image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:12.964993image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.451814image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:16.150613image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:00.245434image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:01.733659image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:03.302173image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:04.683772image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:06.000948image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:07.446739image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:08.776388image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:10.145232image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:11.490811image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:13.091820image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
2022-10-26T09:46:14.583286image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Correlations

2022-10-26T09:46:20.603461image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.
2022-10-26T09:46:20.776341image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2022-10-26T09:46:20.957457image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2022-10-26T09:46:21.142799image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2022-10-26T09:46:21.332762image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2022-10-26T09:46:16.349806image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
A simple visualization of nullity by column.
2022-10-26T09:46:16.582082image/svg+xmlMatplotlib v3.5.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

First rows

df_indexcustomer_idgross_revenuerecency_daysinvoice_noquantityavg_ticketavg_recency_daysfrequencyq_returnsavg_basket_sizeavg_unique_basket_size
00178505391.2100372.000034.00006.000018.152235.50000.486140.000050.97068.7353
11130473232.590056.00009.000011.000018.904027.25000.048835.0000154.444419.0000
22125836705.38002.000015.000024.000028.902523.18750.045750.0000335.200015.4667
3313748948.250095.00005.00008.000033.866192.66670.01790.000087.80005.6000
4415100876.0000333.00003.00002.0000292.00008.60000.136422.000026.66671.0000
55152914623.300025.000014.000017.000045.326523.20000.054429.0000150.14297.2857
66146885630.87007.000021.000024.000017.219818.30000.0736399.0000172.428615.5714
77178095411.910016.000012.000023.000088.719835.70000.039141.0000171.41675.0833
881531160767.90000.000091.000043.000025.54354.14440.3155474.0000419.714326.1429
99160982005.630087.00007.000015.000029.934847.66670.02440.000087.57149.5714

Last rows

df_indexcustomer_idgross_revenuerecency_daysinvoice_noquantityavg_ticketavg_recency_daysfrequencyq_returnsavg_basket_sizeavg_unique_basket_size
29595627177271060.250015.00001.000011.000016.06446.00000.28576.0000645.000066.0000
2960563717232421.52002.00002.000010.000011.708912.00000.15380.0000101.500018.0000
2961563817468137.000010.00002.00002.000027.40004.00000.40000.000058.00002.5000
2962564913596697.04005.00002.000010.00004.19907.00000.25000.0000203.000083.0000
29635655148931237.85009.00002.000014.000016.95682.00000.66670.0000399.500036.5000
2964565912479473.200011.00001.00008.000015.77334.00000.333334.0000382.000030.0000
2965568014126706.13007.00003.00006.000047.07533.00001.000050.0000169.33335.0000
29665686135211092.39001.00003.00009.00002.51124.50000.30000.0000244.3333145.0000
2967569615060301.84008.00004.00008.00002.51531.00002.00000.000065.500030.0000
2968571512558269.96007.00001.00005.000024.54186.00000.2857196.0000196.000011.0000